<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration {
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('user_health_2', function (Blueprint $table) {
            // 日期
            $table->date('created_date')->nullable()->comment('创建日期');
            // 形态
            $table->tinyInteger('ill_xt_pp')->nullable()->default(0)->comment('形态偏胖');
            $table->tinyInteger('ill_xt_ps')->nullable()->default(0)->comment('形态偏瘦');
            $table->tinyInteger('ill_xt_bz')->nullable()->default(0)->comment('形态标准');
            $table->string('ill_xt_ot')->nullable()->default('')->comment('形态其他');
            // 声音
            $table->tinyInteger('ill_sy_dr')->nullable()->default(0)->comment('声音低弱');
            $table->tinyInteger('ill_sy_gk')->nullable()->default(0)->comment('声音高亢');
            $table->string('ill_sy_ot')->nullable()->default('')->comment('声音其他');
            // 面色
            $table->tinyInteger('ill_ms_qh')->nullable()->default(0)->comment('面色青灰');
            $table->tinyInteger('ill_ms_kcsd')->nullable()->default(0)->comment('口唇色淡');
            $table->tinyInteger('ill_ms_msph')->nullable()->default(0)->comment('面色偏红');
            $table->tinyInteger('ill_ms_ch')->nullable()->default(0)->comment('唇红');
            $table->tinyInteger('ill_ms_fh')->nullable()->default(0)->comment('面色发黄');
            $table->tinyInteger('ill_ms_db')->nullable()->default(0)->comment('多斑');
            $table->string('ill_ms_csot')->nullable()->default('')->comment('唇色');
            $table->string('ill_ms_ot')->nullable()->default('')->comment('其他补充');
            // 寒热
            $table->tinyInteger('ill_hr_pl')->nullable()->default(0)->comment('多怕冷');
            $table->tinyInteger('ill_hr_pr')->nullable()->default(0)->comment('多怕热');
            $table->tinyInteger('ill_hr_plpr')->nullable()->default(0)->comment('怕冷又怕热');
            $table->tinyInteger('ill_hr_bplbpr')->nullable()->default(0)->comment('不怕冷不怕热');
            $table->tinyInteger('ill_hr_pf')->nullable()->default(0)->comment('多怕风');
            $table->string('ill_hr_ot')->nullable()->default('')->comment('其他');
            // 饮食
            $table->tinyInteger('ill_ys_ysjc')->nullable()->default(0)->comment('食欲较差');
            $table->tinyInteger('ill_ys_ysws')->nullable()->default(0)->comment('食欲旺盛');
            $table->tinyInteger('ill_ys_yszc')->nullable()->default(0)->comment('食欲正常');
            $table->string('ill_ys_ot')->nullable()->default(0)->comment('');
            // 饮水
            $table->tinyInteger('ill_hs_xwr')->nullable()->default(0)->comment('喜温热');
            $table->tinyInteger('ill_hs_xll')->nullable()->default(0)->comment('喜冷凉');
            $table->tinyInteger('ill_hs_lrjk')->nullable()->default(0)->comment('冷热均可');
            $table->tinyInteger('ill_hs_ky')->nullable()->default(0)->comment('渴饮');
            $table->tinyInteger('ill_hs_ys')->nullable()->default(0)->comment('饮少，不渴饮');
            $table->tinyInteger('ill_hs_ot')->nullable()->default(0)->comment('其他');
            // 大便
            $table->tinyInteger('ill_db_cy')->nullable()->default(0)->comment('大便成形');
            $table->tinyInteger('ill_db_bcy')->nullable()->default(0)->comment('大便不成形');
            $table->tinyInteger('ill_db_gzjk')->nullable()->default(0)->comment('大便干燥结块');
            $table->tinyInteger('ill_db_bm')->nullable()->default(0)->comment('大便便秘');
            $table->tinyInteger('ill_db_fx')->nullable()->default(0)->comment('大便腹泻');
            $table->tinyInteger('ill_db_ljhz')->nullable()->default(0)->comment('大便里急后重');
            $table->tinyInteger('ill_db_zc')->nullable()->default(0)->comment('大便正常');
            $table->string('ill_db_ot')->nullable()->default('')->comment('大便其他');
            // 睡眠
            $table->tinyInteger('ill_sm_sm')->nullable()->default(0)->comment('失眠');
            $table->tinyInteger('ill_sm_smq')->nullable()->default(0)->comment('睡眠浅');
            $table->tinyInteger('ill_sm_dm')->nullable()->default(0)->comment('多梦');
            $table->tinyInteger('ill_sm_zc')->nullable()->default(0)->comment('正常');
            $table->string('ill_sm_ot')->nullable()->default('')->comment('睡眠其他');
            // 痰涕
            $table->tinyInteger('ill_tt_sb')->nullable()->default(0)->comment('痰涕色白');
            $table->tinyInteger('ill_tt_sh')->nullable()->default(0)->comment('痰涕色黄');
            $table->tinyInteger('ill_tt_c')->nullable()->default(0)->comment('痰涕稠');
            $table->tinyInteger('ill_tt_x')->nullable()->default(0)->comment('痰涕稀');
            $table->tinyInteger('ill_tt_ykc')->nullable()->default(0)->comment('痰涕易咳出');
            $table->tinyInteger('ill_tt_bykc')->nullable()->default(0)->comment('痰涕不易咳出');
            $table->tinyInteger('ill_tt_no')->nullable()->default(0)->comment('无');
            $table->string('ill_tt_ot')->nullable()->default('')->comment('其他');
            // 舌像
            $table->string('ill_sx_sz')->nullable()->default('')->comment('舌质');
            $table->string('ill_sx_st')->nullable()->default('')->comment('舌苔');
            $table->string('ill_sx_ot')->nullable()->default('')->comment('其他');
            // 月经
            $table->integer('ill_yj_zq')->nullable()->default(0)->comment('月经周期');
            $table->tinyInteger('ill_yj_ld')->nullable()->default(0)->comment('月经量多');
            $table->tinyInteger('ill_yj_ls')->nullable()->default(0)->comment('月经量少');
            $table->tinyInteger('ill_yj_sd')->nullable()->default(0)->comment('月经色淡');
            $table->tinyInteger('ill_yj_sa')->nullable()->default(0)->comment('月经色暗');
            $table->tinyInteger('ill_yj_xk')->nullable()->default(0)->comment('月经淤血块');
            $table->tinyInteger('ill_yj_xz')->nullable()->default(0)->comment('月经胸胀');
            $table->tinyInteger('ill_yj_tj')->nullable()->default(0)->comment('月经痛经');
            $table->string('ill_yj_ot')->nullable()->default('')->comment('其他');
            // 精神状态
            $table->tinyInteger('ill_js_kfpb')->nullable()->default(0)->comment('精神困乏疲惫');
            $table->tinyInteger('ill_js_kfzd')->nullable()->default(0)->comment('精神亢奋躁动');
            $table->tinyInteger('ill_js_zc')->nullable()->default(0)->comment('精神正常');
            $table->string('ill_js_ot')->nullable()->default('')->comment('其他');
            // 白带
            $table->string('ill_bd_ys')->nullable()->default('')->comment('颜色');
            $table->tinyInteger('ill_bd_ld')->nullable()->default(0)->comment('量大');
            $table->tinyInteger('ill_bd_ls')->nullable()->default(0)->comment('量少');
            $table->string('ill_bd_ot')->nullable()->default('')->comment('其他');
            // 评估总结
            $table->text('summary')->nullable()->comment('评估总结');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('user_health_2', function (Blueprint $table) {
            // 日期
            $table->dropColumn('created_dropColumn');;
// 形态
            $table->dropColumn('ill_xt_pp');
            $table->dropColumn('ill_xt_ps');
            $table->dropColumn('ill_xt_bz');
            $table->dropColumn('ill_xt_ot');
// 声音
            $table->dropColumn('ill_sy_dr');
            $table->dropColumn('ill_sy_gk');
            $table->dropColumn('ill_sy_ot');
// 面色
            $table->dropColumn('ill_ms_qh');
            $table->dropColumn('ill_ms_kcsd');
            $table->dropColumn('ill_ms_msph');
            $table->dropColumn('ill_ms_ch');
            $table->dropColumn('ill_ms_fh');
            $table->dropColumn('ill_ms_db');
            $table->dropColumn('ill_ms_csot');
            $table->dropColumn('ill_ms_ot');
// 寒热
            $table->dropColumn('ill_hr_pl');
            $table->dropColumn('ill_hr_pr');
            $table->dropColumn('ill_hr_plpr');
            $table->dropColumn('ill_hr_bplbpr');
            $table->dropColumn('ill_hr_pf');
            $table->dropColumn('ill_hr_ot');
// 饮食
            $table->dropColumn('ill_ys_ysjc');
            $table->dropColumn('ill_ys_ysws');
            $table->dropColumn('ill_ys_yszc');
            $table->dropColumn('ill_ys_ot');
// 饮水
            $table->dropColumn('ill_hs_xwr');
            $table->dropColumn('ill_hs_xll');
            $table->dropColumn('ill_hs_lrjk');
            $table->dropColumn('ill_hs_ky');
            $table->dropColumn('ill_hs_ys');
            $table->dropColumn('ill_hs_ot');
// 大便
            $table->dropColumn('ill_db_cy');
            $table->dropColumn('ill_db_bcy');
            $table->dropColumn('ill_db_gzjk');
            $table->dropColumn('ill_db_bm');
            $table->dropColumn('ill_db_fx');
            $table->dropColumn('ill_db_ljhz');
            $table->dropColumn('ill_db_zc');
            $table->dropColumn('ill_db_ot');
// 睡眠
            $table->dropColumn('ill_sm_sm');
            $table->dropColumn('ill_sm_smq');
            $table->dropColumn('ill_sm_dm');
            $table->dropColumn('ill_sm_zc');
            $table->dropColumn('ill_sm_ot');
// 痰涕
            $table->dropColumn('ill_tt_sb');
            $table->dropColumn('ill_tt_sh');
            $table->dropColumn('ill_tt_c');
            $table->dropColumn('ill_tt_x');
            $table->dropColumn('ill_tt_ykc');
            $table->dropColumn('ill_tt_bykc');
            $table->dropColumn('ill_tt_no');
            $table->dropColumn('ill_tt_ot');
// 舌像
            $table->dropColumn('ill_sx_sz');
            $table->dropColumn('ill_sx_st');
            $table->dropColumn('ill_sx_ot');
// 月经
            $table->dropColumn('ill_yj_zq');
            $table->dropColumn('ill_yj_ld');
            $table->dropColumn('ill_yj_ls');
            $table->dropColumn('ill_yj_sd');
            $table->dropColumn('ill_yj_sa');
            $table->dropColumn('ill_yj_xk');
            $table->dropColumn('ill_yj_xz');
            $table->dropColumn('ill_yj_tj');
            $table->dropColumn('ill_yj_ot');
// 精神状态
            $table->dropColumn('ill_js_kfpb');
            $table->dropColumn('ill_js_kfzd');
            $table->dropColumn('ill_js_zc');
            $table->dropColumn('ill_js_ot');
// 白带
            $table->dropColumn('ill_bd_ys');
            $table->dropColumn('ill_bd_ld');
            $table->dropColumn('ill_bd_ls');
            $table->dropColumn('ill_bd_ot');
// 评估总结
            $table->dropColumn('summary');
        });
    }
};
